CREATE  PROCEDURE [dbo].[STIGetConfirmList]
AS
SELECT TOP 10
       InvoiceId
       
FROM dbo.STITransaction
WHERE Status = 4
      AND
      (
          SELECT DATEDIFF(HOUR,ResultDate, GETDATE()) AS [Difference in Hours]
      ) >= 2
      AND ResultDate IS NOT NULL